| Attribute/Logical Rolename |
Domain |
Datatype |
NULL |
Definition |
FaStudentAY_ProxyID |
|
BIGINT |
NO |
|
| TableName |
|
VARCHAR(255) |
NO |
|
| RecordID |
|
INTEGER |
NO |
|
| AdEnrollID |
|
INTEGER |
NO |
|
| Sequence |
|
INTEGER |
NO |
|
| OldFaPackStatusID |
|
INTEGER |
NO |
|
| NewFaPackStatusID |
|
INTEGER |
NO |
|
| OldAdGradeLevelID |
|
INTEGER |
NO |
|
| NewAdGradeLevelID |
|
INTEGER |
NO |
|
| OldTuition |
|
MONEY(19, 4) |
YES |
|
| NewTuition |
|
MONEY(19, 4) |
YES |
|
| OldBooksSupplies |
|
MONEY(19, 4) |
YES |
|
| NewBooksSupplies |
|
MONEY(19, 4) |
YES |
|
| OldRoomBoard |
|
MONEY(19, 4) |
YES |
|
| NewRoomBoard |
|
MONEY(19, 4) |
YES |
|
| OldTravel |
|
MONEY(19, 4) |
YES |
|
| NewTravel |
|
MONEY(19, 4) |
YES |
|
| OldBankFees |
|
MONEY(19, 4) |
NO |
|
| NewBankFees |
|
MONEY(19, 4) |
NO |
|
| OldOtherAmount1 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount1 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst1 |
|
BIT |
NO |
|
| NewOtherInst1 |
|
BIT |
NO |
|
| OldOtherDescrip1 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip1 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount2 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount2 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst2 |
|
BIT |
NO |
|
| NewOtherInst2 |
|
BIT |
NO |
|
| OldOtherDescrip2 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip2 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount3 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount3 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst3 |
|
BIT |
NO |
|
| NewOtherInst3 |
|
BIT |
NO |
|
| OldOtherDescrip3 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip3 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount4 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount4 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst4 |
|
BIT |
NO |
|
| NewOtherInst4 |
|
BIT |
NO |
|
| OldOtherDescrip4 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip4 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount5 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount5 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst5 |
|
BIT |
NO |
|
| NewOtherInst5 |
|
BIT |
NO |
|
| OldOtherDescrip5 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip5 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount6 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount6 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst6 |
|
BIT |
NO |
|
| NewOtherInst6 |
|
BIT |
NO |
|
| OldOtherDescrip6 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip6 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount7 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount7 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst7 |
|
BIT |
NO |
|
| NewOtherInst7 |
|
BIT |
NO |
|
| OldOtherDescrip7 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip7 |
|
VARCHAR(40) |
YES |
|
| OldOtherAmount8 |
|
MONEY(19, 4) |
YES |
|
| NewOtherAmount8 |
|
MONEY(19, 4) |
YES |
|
| OldOtherInst8 |
|
BIT |
NO |
|
| NewOtherInst8 |
|
BIT |
NO |
|
| OldOtherDescrip8 |
|
VARCHAR(40) |
YES |
|
| NewOtherDescrip8 |
|
VARCHAR(40) |
YES |
|
| Comment |
|
VARCHAR(400) |
YES |
|
| UserID |
|
INTEGER |
NO |
|
| ModFlag |
|
CHAR(1) |
YES |
|
| NewStartDate |
|
DATETIME |
YES |
|
| NewEndDate |
|
DATETIME |
YES |
|
| OldStartDate |
|
DATETIME |
YES |
|
| OldEndDate |
|
DATETIME |
YES |
|
| OldAwardYear2FAPackStatusID |
|
INTEGER |
YES |
|
| NewAwardYear2FAPackStatusID |
|
INTEGER |
YES |
|
| OldUnsupportedDependent |
|
BIT |
NO |
|
| NewUnsupportedDependent |
|
BIT |
NO |
|
| DateAdded |
|
DATETIME |
NO |
|
| OldExcludeStartDate |
|
BIT |
YES |
|
| NewExcludeStartDate |
|
BIT |
YES |
|
| OldExcludeEndDate |
|
BIT |
YES |
|
| NewExcludeEndDate |
|
BIT |
YES |
|
| NewCreditHoursInAY |
|
NUMERIC(7, 2) |
YES |
|
| OldCreditHoursInAY |
|
NUMERIC(7, 2) |
YES |
|
| NewWeeksInAY |
|
NUMERIC(5, 2) |
YES |
|
| OldWeeksInAY |
|
NUMERIC(5, 2) |
YES |
|
| NewIWINAY |
|
NUMERIC(4, 1) |
YES |
|
| OldIWINAY |
|
NUMERIC(4, 1) |
YES |
|
| NewIWMonths |
|
NUMERIC(4, 1) |
YES |
|
| OldIWMonths |
|
NUMERIC(4, 1) |
YES |
|
| OldFaAutoAwardPopulationConfigurationId |
|
INTEGER |
YES |
|
| NewFaAutoAwardPopulationConfigurationId |
|
INTEGER |
YES |
|